<%@ page import="java.sql.*"%>
<%
int i=0;
String cid= (String)session.getAttribute("cid");
  String bname=(String)session.getAttribute("bname");
  //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//Connection con=DriverManager.getConnection("jdbc:odbc:eti","eti","eti");
  %>
   <%@include file="Connection.jsp" %>

    PreparedStatement st1=con.prepareStatement("select * from taccept where scid=? and sbname=? ");
	   st1.setString(1,cid);
	   st1.setString(2,bname);
ResultSet rs=st1.executeQuery();%>
<body background="img13.jpeg">
<center><font color="#ff8000"><h2><u>Accepted Transactions</u></h2></font><BR><BR>
<table align=center cellpadding="0" border=15 width="85%" cellspacing="0" cellpadding="0">

<tr>
	<td align=center><font color="#80ffff"><b>Source A/C Number</b></font> </td>
	
			<td align=center ><font color="#80ffff"><b>Account Type</b></font></td>
	<td align=center><font color="#80ffff"><b>Name of Bank</b></font></td>
	<td align=center><font color="#80ffff"><b>Amount</b></font></td>
	<td align=center><font color="#80ffff"><b>Destination A/C Number</b></font></td>
	<td align=center><font color="#80ffff"><b>Balance</b></font></td>
				</tr><%
while(rs.next())
{
	i++;
	%>
	<tr>
	<td align=center><font color="#ffff00"><%=rs.getString(2)%></font></td>
	<td align=center><font color="#ffff00"><%=rs.getString(3)%></font></td>
	<td align=center><font color="#ffff00"><%=rs.getString(4)%></font></td>
	<td align=center><font color="#ffff00"><%=rs.getFloat(10)%></font></td> 
	<td align=center><font color="#ffff00"><%=rs.getString(7)%></font></td>
	<td align=center><font color="#ffff00"><%=rs.getFloat(5)%></font> </td></tr>
<%
		}
  %>
  </table>
  <center><BR><BR><BR>
<input type="button" name=back  value="   BACK   " onClick="window.location='treport.jsp'">
</center></center>
</body>